Python Job: Database Architect

We are on a mission to make science open so everyone can live healthy lives on a healthy planet

Who we are

Frontiers is an award-winning open science platform and leading open access scholarly publisher.

We are one of the largest and most cited publishers globally. To date, our 200,000 freely available research articles have received more than 1 billion views and downloads and 2 million citations. Our journals span science, health, humanities and social sciences, engineering, and sustainability. And we continue to expand into new academic disciplines so more researchers can publish open access.

Be part of the publishing revolution and help us transform the way research is published, evaluated, and communicated to the world.

Job Role 

We are currently looking for a Data Architect to help us improve or even re-design the Publishing Operations platform data layer, lead Data Engineers and drive the development of future Data Products that will expose our data to third parties like Data Science, Data Reporting, Machine Learning or other departments. 

The ideal candidate will have hands-on experience designing data-intensive applications and big data solutions, and we also expect a good knowledge of all types of data storage: structured files, relational databases, documental databases, graph databases, etc. 

You would work in a fast-paced environment while juggling several different tasks and initiatives simultaneously, where innovation and green-field development would be a part of your daily job but so would be supporting product teams developers to build correct data models or collaborating with other external teams to carry out cross-team goals. 

Key Responsibilities 

• Be a member of the Publishing Operations – R&D and Core Architecture team, working closely with the Solutions Architect, data engineers, software engineers and the Product Development Teams 

• Use MSSQL, Postgresql, Kafka, GraphQL, Azure and other technologies to architect and develop our future Data Products -  queryable and streamable data platforms that enable data exchange between our internal systems’ operational data and external consumers 

• Own the Data architecture of the Publishing Operations platform 

• Translate business requirements coming from Data Science, Data Reporting, Machine Learning or other departments into technical specifications and design of data streams, integrations, transformations, databases, or data warehouses 

• Create and maintain up to date documents describing the Data Architecture strategy of your application’s domain, as well as all relevant guidelines and standards

• Use your knowledge of relational databases, document databases, data performance and security to support the Product Development teams in the modelling, designing, construction, evolution, and decommission of their data-intensive applications and data models 

• Understand and promote the best Data frameworks and solutions, technical standards, and key technologies, to effectively support existing and future business requirements 

Requirements 

• Proven experience as a Data Architect or Senior Data Engineer 

• In-depth understanding of database structure principles 

• Proficiency with any relational database engines (MS SQL Server, PostgreSQL) 

• Experience in design and development of custom ELT/ETL solutions 

• Expertise in data processing: data ingest and transformation, batch processing, streaming data processing, distributed processing, monitoring, optimization, logging 

• Experience with any programming language like .NET, Java, Python. 

• Experience with a Cloud Platform (e.g. Azure, AWS, GCP) 

• Outstanding problem-solving abilities 

• Basic DevOps understanding 

Nice to have

• Experience with Streaming ETLs with Kafka or Confluent 

• Experience with Kubernetes 

• Experience building Data Lakes

• Knowledge of data security standards. 

• Experience of non-relational database engines (MongoDB, Elastic Search) 

Benefits

With more than 50 nationalities represented in our global team, you will work regularly with teammates in other countries, and with our community of researchers, editors, and authors from around the globe.

Our mission to create solutions for healthy lives also extends to the working environment we provide for our employees.

This includes:

100% remote working

Employees now have the flexibility to choose where they want to work, with remote working available on a part- or full-time basis (not applicable to some Workplace/IT jobs due to nature of role requiring presence onsite, in the office).

Learning and development

All employees have access to LinkedIn Learning (and Pluralsight for our technology team), an annual personal learning budget, and dedicated L&D time.

Wellbeing

We offer free online yoga classes, an employee assistance plan, access to the Headspace app, and four wellbeing days on top of your annual leave allowance.

Volunteering opportunities

Employees can dedicate three days each year to volunteer for a personal cause or through our volunteering partner platform, Alaya.

Frontiers actively embraces diversity and is a safe and welcoming workplace. Recruitment is free from discrimination – including based on race, national or ethnic origin, age, religion, disability, sex, gender identity or sexual orientation. With over 600 employees from more than 50 different nations, our diversity creates vibrant teams and constantly challenges us to appreciate multiple perspectives.

Job Type: Full-time

Schedule:

• Monday to Friday